﻿CREATE TABLE [dbo].[CiSequence] (
    [Id]          INT            IDENTITY (1, 1) NOT NULL,
    [FullName]    NVARCHAR (200) NOT NULL,
    [Prefix]      NVARCHAR (50)  NULL,
    [Separate]    NVARCHAR (50)  NULL,
    [Sequence]    INT            DEFAULT ((10000000)) NOT NULL,
    [Reduction]   INT            DEFAULT ((9999999)) NOT NULL,
    [Step]        INT            DEFAULT ((1)) NOT NULL,
    [CreateOn]    DATETIME       DEFAULT (getdate()) NOT NULL,
    [Description] NVARCHAR (800) NULL,
    CONSTRAINT [PK_CISEQUENCE] PRIMARY KEY NONCLUSTERED ([Id] ASC)
);

